package com.maybach.common.query;


import com.maybach.util.query.support.BaseQuery;
import com.maybach.util.query.support.BaseCriteria;
import org.apache.commons.lang.builder.ReflectionToStringBuilder;
import org.apache.commons.lang.builder.ToStringStyle;

import java.io.Serializable;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class PartnerQuery extends BaseQuery implements Serializable {
    private static final long serialVersionUID = 1L;

    public PartnerQuery() {
        super();
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        super.oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * This class corresponds to the database table b2b_partner
     */
    protected abstract static class GeneratedCriteria extends BaseCriteria {

        protected GeneratedCriteria() {
            super();
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNull() {
            addCriterion("gmt_create is null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIsNotNull() {
            addCriterion("gmt_create is not null");
            return (Criteria) this;
        }

        public Criteria andGmtCreateEqualTo(Date value) {
            addCriterion("gmt_create =", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotEqualTo(Date value) {
            addCriterion("gmt_create <>", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThan(Date value) {
            addCriterion("gmt_create >", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_create >=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThan(Date value) {
            addCriterion("gmt_create <", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateLessThanOrEqualTo(Date value) {
            addCriterion("gmt_create <=", value, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateIn(List<Date> values) {
            addCriterion("gmt_create in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotIn(List<Date> values) {
            addCriterion("gmt_create not in", values, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateBetween(Date value1, Date value2) {
            addCriterion("gmt_create between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtCreateNotBetween(Date value1, Date value2) {
            addCriterion("gmt_create not between", value1, value2, "gmtCreate");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNull() {
            addCriterion("gmt_modified is null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIsNotNull() {
            addCriterion("gmt_modified is not null");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedEqualTo(Date value) {
            addCriterion("gmt_modified =", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotEqualTo(Date value) {
            addCriterion("gmt_modified <>", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThan(Date value) {
            addCriterion("gmt_modified >", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedGreaterThanOrEqualTo(Date value) {
            addCriterion("gmt_modified >=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThan(Date value) {
            addCriterion("gmt_modified <", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedLessThanOrEqualTo(Date value) {
            addCriterion("gmt_modified <=", value, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedIn(List<Date> values) {
            addCriterion("gmt_modified in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotIn(List<Date> values) {
            addCriterion("gmt_modified not in", values, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedBetween(Date value1, Date value2) {
            addCriterion("gmt_modified between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andGmtModifiedNotBetween(Date value1, Date value2) {
            addCriterion("gmt_modified not between", value1, value2, "gmtModified");
            return (Criteria) this;
        }

        public Criteria andCorpNameIsNull() {
            addCriterion("corp_name is null");
            return (Criteria) this;
        }

        public Criteria andCorpNameIsNotNull() {
            addCriterion("corp_name is not null");
            return (Criteria) this;
        }

        public Criteria andCorpNameEqualTo(String value) {
            addCriterion("corp_name =", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameNotEqualTo(String value) {
            addCriterion("corp_name <>", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameGreaterThan(String value) {
            addCriterion("corp_name >", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameGreaterThanOrEqualTo(String value) {
            addCriterion("corp_name >=", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameLessThan(String value) {
            addCriterion("corp_name <", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameLessThanOrEqualTo(String value) {
            addCriterion("corp_name <=", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameLike(String value) {
            addCriterion("corp_name like", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameNotLike(String value) {
            addCriterion("corp_name not like", value, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameIn(List<String> values) {
            addCriterion("corp_name in", values, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameNotIn(List<String> values) {
            addCriterion("corp_name not in", values, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameBetween(String value1, String value2) {
            addCriterion("corp_name between", value1, value2, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpNameNotBetween(String value1, String value2) {
            addCriterion("corp_name not between", value1, value2, "corpName");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionIsNull() {
            addCriterion("corp_description is null");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionIsNotNull() {
            addCriterion("corp_description is not null");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionEqualTo(String value) {
            addCriterion("corp_description =", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionNotEqualTo(String value) {
            addCriterion("corp_description <>", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionGreaterThan(String value) {
            addCriterion("corp_description >", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("corp_description >=", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionLessThan(String value) {
            addCriterion("corp_description <", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionLessThanOrEqualTo(String value) {
            addCriterion("corp_description <=", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionLike(String value) {
            addCriterion("corp_description like", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionNotLike(String value) {
            addCriterion("corp_description not like", value, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionIn(List<String> values) {
            addCriterion("corp_description in", values, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionNotIn(List<String> values) {
            addCriterion("corp_description not in", values, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionBetween(String value1, String value2) {
            addCriterion("corp_description between", value1, value2, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andCorpDescriptionNotBetween(String value1, String value2) {
            addCriterion("corp_description not between", value1, value2, "corpDescription");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceIsNull() {
            addCriterion("account_balance is null");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceIsNotNull() {
            addCriterion("account_balance is not null");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceEqualTo(Long value) {
            addCriterion("account_balance =", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceNotEqualTo(Long value) {
            addCriterion("account_balance <>", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceGreaterThan(Long value) {
            addCriterion("account_balance >", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceGreaterThanOrEqualTo(Long value) {
            addCriterion("account_balance >=", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceLessThan(Long value) {
            addCriterion("account_balance <", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceLessThanOrEqualTo(Long value) {
            addCriterion("account_balance <=", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceLike(Long value) {
            addCriterion("account_balance like", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceNotLike(Long value) {
            addCriterion("account_balance not like", value, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceIn(List<Long> values) {
            addCriterion("account_balance in", values, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceNotIn(List<Long> values) {
            addCriterion("account_balance not in", values, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceBetween(Long value1, Long value2) {
            addCriterion("account_balance between", value1, value2, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andAccountBalanceNotBetween(Long value1, Long value2) {
            addCriterion("account_balance not between", value1, value2, "accountBalance");
            return (Criteria) this;
        }

        public Criteria andContactsNameIsNull() {
            addCriterion("contacts_name is null");
            return (Criteria) this;
        }

        public Criteria andContactsNameIsNotNull() {
            addCriterion("contacts_name is not null");
            return (Criteria) this;
        }

        public Criteria andContactsNameEqualTo(String value) {
            addCriterion("contacts_name =", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameNotEqualTo(String value) {
            addCriterion("contacts_name <>", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameGreaterThan(String value) {
            addCriterion("contacts_name >", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameGreaterThanOrEqualTo(String value) {
            addCriterion("contacts_name >=", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameLessThan(String value) {
            addCriterion("contacts_name <", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameLessThanOrEqualTo(String value) {
            addCriterion("contacts_name <=", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameLike(String value) {
            addCriterion("contacts_name like", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameNotLike(String value) {
            addCriterion("contacts_name not like", value, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameIn(List<String> values) {
            addCriterion("contacts_name in", values, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameNotIn(List<String> values) {
            addCriterion("contacts_name not in", values, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameBetween(String value1, String value2) {
            addCriterion("contacts_name between", value1, value2, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsNameNotBetween(String value1, String value2) {
            addCriterion("contacts_name not between", value1, value2, "contactsName");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNull() {
            addCriterion("contacts_phone is null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIsNotNull() {
            addCriterion("contacts_phone is not null");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneEqualTo(String value) {
            addCriterion("contacts_phone =", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotEqualTo(String value) {
            addCriterion("contacts_phone <>", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThan(String value) {
            addCriterion("contacts_phone >", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("contacts_phone >=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThan(String value) {
            addCriterion("contacts_phone <", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLessThanOrEqualTo(String value) {
            addCriterion("contacts_phone <=", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneLike(String value) {
            addCriterion("contacts_phone like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotLike(String value) {
            addCriterion("contacts_phone not like", value, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneIn(List<String> values) {
            addCriterion("contacts_phone in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotIn(List<String> values) {
            addCriterion("contacts_phone not in", values, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneBetween(String value1, String value2) {
            addCriterion("contacts_phone between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andContactsPhoneNotBetween(String value1, String value2) {
            addCriterion("contacts_phone not between", value1, value2, "contactsPhone");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNull() {
            addCriterion("city_id is null");
            return (Criteria) this;
        }

        public Criteria andCityIdIsNotNull() {
            addCriterion("city_id is not null");
            return (Criteria) this;
        }

        public Criteria andCityIdEqualTo(Integer value) {
            addCriterion("city_id =", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotEqualTo(Integer value) {
            addCriterion("city_id <>", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThan(Integer value) {
            addCriterion("city_id >", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("city_id >=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThan(Integer value) {
            addCriterion("city_id <", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLessThanOrEqualTo(Integer value) {
            addCriterion("city_id <=", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdLike(Integer value) {
            addCriterion("city_id like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotLike(Integer value) {
            addCriterion("city_id not like", value, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdIn(List<Integer> values) {
            addCriterion("city_id in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotIn(List<Integer> values) {
            addCriterion("city_id not in", values, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdBetween(Integer value1, Integer value2) {
            addCriterion("city_id between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityIdNotBetween(Integer value1, Integer value2) {
            addCriterion("city_id not between", value1, value2, "cityId");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNull() {
            addCriterion("city_name is null");
            return (Criteria) this;
        }

        public Criteria andCityNameIsNotNull() {
            addCriterion("city_name is not null");
            return (Criteria) this;
        }

        public Criteria andCityNameEqualTo(String value) {
            addCriterion("city_name =", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotEqualTo(String value) {
            addCriterion("city_name <>", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThan(String value) {
            addCriterion("city_name >", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameGreaterThanOrEqualTo(String value) {
            addCriterion("city_name >=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThan(String value) {
            addCriterion("city_name <", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLessThanOrEqualTo(String value) {
            addCriterion("city_name <=", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameLike(String value) {
            addCriterion("city_name like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotLike(String value) {
            addCriterion("city_name not like", value, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameIn(List<String> values) {
            addCriterion("city_name in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotIn(List<String> values) {
            addCriterion("city_name not in", values, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameBetween(String value1, String value2) {
            addCriterion("city_name between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andCityNameNotBetween(String value1, String value2) {
            addCriterion("city_name not between", value1, value2, "cityName");
            return (Criteria) this;
        }

        public Criteria andProviceIdIsNull() {
            addCriterion("provice_id is null");
            return (Criteria) this;
        }

        public Criteria andProviceIdIsNotNull() {
            addCriterion("provice_id is not null");
            return (Criteria) this;
        }

        public Criteria andProviceIdEqualTo(Integer value) {
            addCriterion("provice_id =", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdNotEqualTo(Integer value) {
            addCriterion("provice_id <>", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdGreaterThan(Integer value) {
            addCriterion("provice_id >", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("provice_id >=", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdLessThan(Integer value) {
            addCriterion("provice_id <", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdLessThanOrEqualTo(Integer value) {
            addCriterion("provice_id <=", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdLike(Integer value) {
            addCriterion("provice_id like", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdNotLike(Integer value) {
            addCriterion("provice_id not like", value, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdIn(List<Integer> values) {
            addCriterion("provice_id in", values, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdNotIn(List<Integer> values) {
            addCriterion("provice_id not in", values, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdBetween(Integer value1, Integer value2) {
            addCriterion("provice_id between", value1, value2, "proviceId");
            return (Criteria) this;
        }

        public Criteria andProviceIdNotBetween(Integer value1, Integer value2) {
            addCriterion("provice_id not between", value1, value2, "proviceId");
            return (Criteria) this;
        }

        public Criteria andDetailAddressIsNull() {
            addCriterion("detail_address is null");
            return (Criteria) this;
        }

        public Criteria andDetailAddressIsNotNull() {
            addCriterion("detail_address is not null");
            return (Criteria) this;
        }

        public Criteria andDetailAddressEqualTo(String value) {
            addCriterion("detail_address =", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressNotEqualTo(String value) {
            addCriterion("detail_address <>", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressGreaterThan(String value) {
            addCriterion("detail_address >", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressGreaterThanOrEqualTo(String value) {
            addCriterion("detail_address >=", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressLessThan(String value) {
            addCriterion("detail_address <", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressLessThanOrEqualTo(String value) {
            addCriterion("detail_address <=", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressLike(String value) {
            addCriterion("detail_address like", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressNotLike(String value) {
            addCriterion("detail_address not like", value, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressIn(List<String> values) {
            addCriterion("detail_address in", values, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressNotIn(List<String> values) {
            addCriterion("detail_address not in", values, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressBetween(String value1, String value2) {
            addCriterion("detail_address between", value1, value2, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andDetailAddressNotBetween(String value1, String value2) {
            addCriterion("detail_address not between", value1, value2, "detailAddress");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsIsNull() {
            addCriterion("credentials_imgs is null");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsIsNotNull() {
            addCriterion("credentials_imgs is not null");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsEqualTo(String value) {
            addCriterion("credentials_imgs =", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsNotEqualTo(String value) {
            addCriterion("credentials_imgs <>", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsGreaterThan(String value) {
            addCriterion("credentials_imgs >", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsGreaterThanOrEqualTo(String value) {
            addCriterion("credentials_imgs >=", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsLessThan(String value) {
            addCriterion("credentials_imgs <", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsLessThanOrEqualTo(String value) {
            addCriterion("credentials_imgs <=", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsLike(String value) {
            addCriterion("credentials_imgs like", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsNotLike(String value) {
            addCriterion("credentials_imgs not like", value, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsIn(List<String> values) {
            addCriterion("credentials_imgs in", values, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsNotIn(List<String> values) {
            addCriterion("credentials_imgs not in", values, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsBetween(String value1, String value2) {
            addCriterion("credentials_imgs between", value1, value2, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCredentialsImgsNotBetween(String value1, String value2) {
            addCriterion("credentials_imgs not between", value1, value2, "credentialsImgs");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNull() {
            addCriterion("certificate_code is null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNotNull() {
            addCriterion("certificate_code is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeEqualTo(String value) {
            addCriterion("certificate_code =", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotEqualTo(String value) {
            addCriterion("certificate_code <>", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThan(String value) {
            addCriterion("certificate_code >", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThanOrEqualTo(String value) {
            addCriterion("certificate_code >=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThan(String value) {
            addCriterion("certificate_code <", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThanOrEqualTo(String value) {
            addCriterion("certificate_code <=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLike(String value) {
            addCriterion("certificate_code like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotLike(String value) {
            addCriterion("certificate_code not like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIn(List<String> values) {
            addCriterion("certificate_code in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotIn(List<String> values) {
            addCriterion("certificate_code not in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeBetween(String value1, String value2) {
            addCriterion("certificate_code between", value1, value2, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotBetween(String value1, String value2) {
            addCriterion("certificate_code not between", value1, value2, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("type is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("type is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("type =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("type <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("type >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("type >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("type <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("type <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLike(Integer value) {
            addCriterion("type like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotLike(Integer value) {
            addCriterion("type not like", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("type in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("type not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("type between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("type not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andStoreImgsIsNull() {
            addCriterion("store_imgs is null");
            return (Criteria) this;
        }

        public Criteria andStoreImgsIsNotNull() {
            addCriterion("store_imgs is not null");
            return (Criteria) this;
        }

        public Criteria andStoreImgsEqualTo(String value) {
            addCriterion("store_imgs =", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsNotEqualTo(String value) {
            addCriterion("store_imgs <>", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsGreaterThan(String value) {
            addCriterion("store_imgs >", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsGreaterThanOrEqualTo(String value) {
            addCriterion("store_imgs >=", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsLessThan(String value) {
            addCriterion("store_imgs <", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsLessThanOrEqualTo(String value) {
            addCriterion("store_imgs <=", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsLike(String value) {
            addCriterion("store_imgs like", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsNotLike(String value) {
            addCriterion("store_imgs not like", value, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsIn(List<String> values) {
            addCriterion("store_imgs in", values, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsNotIn(List<String> values) {
            addCriterion("store_imgs not in", values, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsBetween(String value1, String value2) {
            addCriterion("store_imgs between", value1, value2, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andStoreImgsNotBetween(String value1, String value2) {
            addCriterion("store_imgs not between", value1, value2, "storeImgs");
            return (Criteria) this;
        }

        public Criteria andMemoIsNull() {
            addCriterion("memo is null");
            return (Criteria) this;
        }

        public Criteria andMemoIsNotNull() {
            addCriterion("memo is not null");
            return (Criteria) this;
        }

        public Criteria andMemoEqualTo(String value) {
            addCriterion("memo =", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotEqualTo(String value) {
            addCriterion("memo <>", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThan(String value) {
            addCriterion("memo >", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoGreaterThanOrEqualTo(String value) {
            addCriterion("memo >=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThan(String value) {
            addCriterion("memo <", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLessThanOrEqualTo(String value) {
            addCriterion("memo <=", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoLike(String value) {
            addCriterion("memo like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotLike(String value) {
            addCriterion("memo not like", value, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoIn(List<String> values) {
            addCriterion("memo in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotIn(List<String> values) {
            addCriterion("memo not in", values, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoBetween(String value1, String value2) {
            addCriterion("memo between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andMemoNotBetween(String value1, String value2) {
            addCriterion("memo not between", value1, value2, "memo");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLike(Integer value) {
            addCriterion("status like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotLike(Integer value) {
            addCriterion("status not like", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIsNull() {
            addCriterion("is_verify is null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIsNotNull() {
            addCriterion("is_verify is not null");
            return (Criteria) this;
        }

        public Criteria andIsVerifyEqualTo(Integer value) {
            addCriterion("is_verify =", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyNotEqualTo(Integer value) {
            addCriterion("is_verify <>", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyGreaterThan(Integer value) {
            addCriterion("is_verify >", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_verify >=", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyLessThan(Integer value) {
            addCriterion("is_verify <", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyLessThanOrEqualTo(Integer value) {
            addCriterion("is_verify <=", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyLike(Integer value) {
            addCriterion("is_verify like", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyNotLike(Integer value) {
            addCriterion("is_verify not like", value, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyIn(List<Integer> values) {
            addCriterion("is_verify in", values, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyNotIn(List<Integer> values) {
            addCriterion("is_verify not in", values, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyBetween(Integer value1, Integer value2) {
            addCriterion("is_verify between", value1, value2, "isVerify");
            return (Criteria) this;
        }

        public Criteria andIsVerifyNotBetween(Integer value1, Integer value2) {
            addCriterion("is_verify not between", value1, value2, "isVerify");
            return (Criteria) this;
        }

        public Criteria andContractImgsIsNull() {
            addCriterion("contract_imgs is null");
            return (Criteria) this;
        }

        public Criteria andContractImgsIsNotNull() {
            addCriterion("contract_imgs is not null");
            return (Criteria) this;
        }

        public Criteria andContractImgsEqualTo(String value) {
            addCriterion("contract_imgs =", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsNotEqualTo(String value) {
            addCriterion("contract_imgs <>", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsGreaterThan(String value) {
            addCriterion("contract_imgs >", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsGreaterThanOrEqualTo(String value) {
            addCriterion("contract_imgs >=", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsLessThan(String value) {
            addCriterion("contract_imgs <", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsLessThanOrEqualTo(String value) {
            addCriterion("contract_imgs <=", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsLike(String value) {
            addCriterion("contract_imgs like", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsNotLike(String value) {
            addCriterion("contract_imgs not like", value, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsIn(List<String> values) {
            addCriterion("contract_imgs in", values, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsNotIn(List<String> values) {
            addCriterion("contract_imgs not in", values, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsBetween(String value1, String value2) {
            addCriterion("contract_imgs between", value1, value2, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andContractImgsNotBetween(String value1, String value2) {
            addCriterion("contract_imgs not between", value1, value2, "contractImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsIsNull() {
            addCriterion("corp_logo_imgs is null");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsIsNotNull() {
            addCriterion("corp_logo_imgs is not null");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsEqualTo(String value) {
            addCriterion("corp_logo_imgs =", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsNotEqualTo(String value) {
            addCriterion("corp_logo_imgs <>", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsGreaterThan(String value) {
            addCriterion("corp_logo_imgs >", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsGreaterThanOrEqualTo(String value) {
            addCriterion("corp_logo_imgs >=", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsLessThan(String value) {
            addCriterion("corp_logo_imgs <", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsLessThanOrEqualTo(String value) {
            addCriterion("corp_logo_imgs <=", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsLike(String value) {
            addCriterion("corp_logo_imgs like", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsNotLike(String value) {
            addCriterion("corp_logo_imgs not like", value, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsIn(List<String> values) {
            addCriterion("corp_logo_imgs in", values, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsNotIn(List<String> values) {
            addCriterion("corp_logo_imgs not in", values, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsBetween(String value1, String value2) {
            addCriterion("corp_logo_imgs between", value1, value2, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andCorpLogoImgsNotBetween(String value1, String value2) {
            addCriterion("corp_logo_imgs not between", value1, value2, "corpLogoImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsIsNull() {
            addCriterion("legal_cert_imgs is null");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsIsNotNull() {
            addCriterion("legal_cert_imgs is not null");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsEqualTo(String value) {
            addCriterion("legal_cert_imgs =", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsNotEqualTo(String value) {
            addCriterion("legal_cert_imgs <>", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsGreaterThan(String value) {
            addCriterion("legal_cert_imgs >", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsGreaterThanOrEqualTo(String value) {
            addCriterion("legal_cert_imgs >=", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsLessThan(String value) {
            addCriterion("legal_cert_imgs <", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsLessThanOrEqualTo(String value) {
            addCriterion("legal_cert_imgs <=", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsLike(String value) {
            addCriterion("legal_cert_imgs like", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsNotLike(String value) {
            addCriterion("legal_cert_imgs not like", value, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsIn(List<String> values) {
            addCriterion("legal_cert_imgs in", values, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsNotIn(List<String> values) {
            addCriterion("legal_cert_imgs not in", values, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsBetween(String value1, String value2) {
            addCriterion("legal_cert_imgs between", value1, value2, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andLegalCertImgsNotBetween(String value1, String value2) {
            addCriterion("legal_cert_imgs not between", value1, value2, "legalCertImgs");
            return (Criteria) this;
        }

        public Criteria andAttributesIsNull() {
            addCriterion("attributes is null");
            return (Criteria) this;
        }

        public Criteria andAttributesIsNotNull() {
            addCriterion("attributes is not null");
            return (Criteria) this;
        }

        public Criteria andAttributesEqualTo(String value) {
            addCriterion("attributes =", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesNotEqualTo(String value) {
            addCriterion("attributes <>", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesGreaterThan(String value) {
            addCriterion("attributes >", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesGreaterThanOrEqualTo(String value) {
            addCriterion("attributes >=", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesLessThan(String value) {
            addCriterion("attributes <", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesLessThanOrEqualTo(String value) {
            addCriterion("attributes <=", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesLike(String value) {
            addCriterion("attributes like", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesNotLike(String value) {
            addCriterion("attributes not like", value, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesIn(List<String> values) {
            addCriterion("attributes in", values, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesNotIn(List<String> values) {
            addCriterion("attributes not in", values, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesBetween(String value1, String value2) {
            addCriterion("attributes between", value1, value2, "attributes");
            return (Criteria) this;
        }

        public Criteria andAttributesNotBetween(String value1, String value2) {
            addCriterion("attributes not between", value1, value2, "attributes");
            return (Criteria) this;
        }

        public Criteria andCreatorUserIsNull() {
            addCriterion("creator_user is null");
            return (Criteria) this;
        }

        public Criteria andCreatorUserIsNotNull() {
            addCriterion("creator_user is not null");
            return (Criteria) this;
        }

        public Criteria andCreatorUserEqualTo(String value) {
            addCriterion("creator_user =", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserNotEqualTo(String value) {
            addCriterion("creator_user <>", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserGreaterThan(String value) {
            addCriterion("creator_user >", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserGreaterThanOrEqualTo(String value) {
            addCriterion("creator_user >=", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserLessThan(String value) {
            addCriterion("creator_user <", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserLessThanOrEqualTo(String value) {
            addCriterion("creator_user <=", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserLike(String value) {
            addCriterion("creator_user like", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserNotLike(String value) {
            addCriterion("creator_user not like", value, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserIn(List<String> values) {
            addCriterion("creator_user in", values, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserNotIn(List<String> values) {
            addCriterion("creator_user not in", values, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserBetween(String value1, String value2) {
            addCriterion("creator_user between", value1, value2, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andCreatorUserNotBetween(String value1, String value2) {
            addCriterion("creator_user not between", value1, value2, "creatorUser");
            return (Criteria) this;
        }

        public Criteria andManagerIsNull() {
            addCriterion("manager is null");
            return (Criteria) this;
        }

        public Criteria andManagerIsNotNull() {
            addCriterion("manager is not null");
            return (Criteria) this;
        }

        public Criteria andManagerEqualTo(String value) {
            addCriterion("manager =", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotEqualTo(String value) {
            addCriterion("manager <>", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerGreaterThan(String value) {
            addCriterion("manager >", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerGreaterThanOrEqualTo(String value) {
            addCriterion("manager >=", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLessThan(String value) {
            addCriterion("manager <", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLessThanOrEqualTo(String value) {
            addCriterion("manager <=", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerLike(String value) {
            addCriterion("manager like", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotLike(String value) {
            addCriterion("manager not like", value, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerIn(List<String> values) {
            addCriterion("manager in", values, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotIn(List<String> values) {
            addCriterion("manager not in", values, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerBetween(String value1, String value2) {
            addCriterion("manager between", value1, value2, "manager");
            return (Criteria) this;
        }

        public Criteria andManagerNotBetween(String value1, String value2) {
            addCriterion("manager not between", value1, value2, "manager");
            return (Criteria) this;
        }

    }

    /**
     * This class corresponds to the database table b2b_partner
    */
    public  static class Criteria extends GeneratedCriteria{
        protected Criteria() {
            super();
        }
    }



    @Override
    public String toString(){
        return ReflectionToStringBuilder.toString(this, ToStringStyle.DEFAULT_STYLE);
    }
}